<%@page import="java.sql.*"%>
<%@page import="jobportal.Dbconn" %>






<%
                                                Connection con = Dbconn.getConn();
                                                Statement st = con.createStatement();

                                                ResultSet rs1;
                                    %>
<table width="300" height="206" border="0" cellpadding="0" cellspacing="0" style="overflow:hidden;">
                                                            <tbody>
                                                                <tr class="pnl_hdg">
                                                                    <td align="center" valign="middle" width="24" height="24">
                                                                        <div class="latjob_icon">                                                                        </div>                                                                    </td>
                                                                    <td align="left" valign="middle" height="24" width="271">
                                                                        Latest Jobs<img src="./images/latestjobsimage.jpg" width="25" height="15" style="margin-right:2px; ">                                                                    </td>
                                                                </tr>

                                                                <tr>
                                                                    <td align="left" valign="top" colspan="2">
                                                                        <marquee behavior="scroll" scrollamount="3" direction="up" loop="-1" onmouseover="this.setAttribute(&#39;scrollamount&#39;, 0, 0); " onmouseout="this.setAttribute(&#39;scrollamount&#39;, 3, 0);" style="height:175px; margin-left:10px; width:290px; " >
                                                                            <ul id="testomonial">
                                                                                <%try{
                                                                                            rs1 = st.executeQuery("select jobid,jobtitle,jobdesc,jobrole,joblocation,keyskill,company.compid,compname from jobs,company where jobs.compid=company.compid and jobs.status='Active' ");
                                                                                            while (rs1.next()) {
                %>
                                                                                <li>
                                                                                    <strong>
                                                                                        <span class="right_arrow">                                                                                        </span>
                                                                                         <img src="src/getpic.jsp?id=<%=rs1.getString("company.compid")%>&table=company&col=logo&pk_col=compid" width="66" height="35" border="0" /><a class="link" href="" target="_blank">
                                                                                            <strong><font size="+1"></br>
                                                                                            </font>                                                                                     </strong>                                                                                        </a>

                                                                                       </br>
                                                                              </strong></li>
													                            <li><strong>
                                                                                Company
                                                                                </strong>
                                                                                : <%=rs1.getString("compname")%>                                                                                            </br>                                                                                        </a>                                                                                    </strong>
                                                                                    </br><strong>
                                                                                        <br/>
                                                                                        Job Title
                                                                                    </strong>
                                                                        : <a class="link" href="viewjobdetails.jsp?jobid=<%=rs1.getString("jobid")%>" target="_blank"><%=rs1.getString("jobtitle")%></a><br/>

                                                                                    <strong>Location</strong>: <%=rs1.getString("joblocation")%>
                                                                                    <strong>
                                                                                        <br/>
                                                                                        KeySkill                                                                                    </strong>
                                                                                    : <%=rs1.getString("keyskill")%><br/>
                                                                                </li>
												                              <br/><br/><br/><br/>
                                                                                <% }}catch(Exception e){
                                                                                out.println(e);
}%>
                                                                            </ul>
                                                                      </marquee>                                                                    </td>
                                                                </tr>

                                                            </tbody>
                                                        </table>

 